/*
 Navicat Premium Data Transfer

 Source Server         : node-data-serve
 Source Server Type    : MySQL
 Source Server Version : 80033 (8.0.33)
 Source Host           : localhost:3306
 Source Schema         : table_data_manage

 Target Server Type    : MySQL
 Target Server Version : 80033 (8.0.33)
 File Encoding         : 65001

 Date: 17/07/2023 15:18:48
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user_info_manage
-- ----------------------------
DROP TABLE IF EXISTS `user_info_manage`;
CREATE TABLE `user_info_manage` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '用户唯一标识',
  `user_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户名',
  `user_address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户地址',
  `user_remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户备注',
  `is_delete_status` tinyint DEFAULT '1' COMMENT '删除逻辑，1指未删除，0指已删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of user_info_manage
-- ----------------------------
BEGIN;
INSERT INTO `user_info_manage` (`id`, `user_name`, `user_address`, `user_remark`, `is_delete_status`) VALUES (1, '郑华娜', '香港北区香港粉岭和丰街547号', '测试人员', 1);
INSERT INTO `user_info_manage` (`id`, `user_name`, `user_address`, `user_remark`, `is_delete_status`) VALUES (2, '杨国健', '香港沙田区新界火炭山尾街395号', '测试人员', 1);
INSERT INTO `user_info_manage` (`id`, `user_name`, `user_address`, `user_remark`, `is_delete_status`) VALUES (3, '郑宝康', '香港观塘区蓝田安田街607号', '测试人员', 0);
INSERT INTO `user_info_manage` (`id`, `user_name`, `user_address`, `user_remark`, `is_delete_status`) VALUES (5, '刘英和', '香港东区高士威道591号', '测试人员', 1);
INSERT INTO `user_info_manage` (`id`, `user_name`, `user_address`, `user_remark`, `is_delete_status`) VALUES (6, '陈全寿', '香港南区路713号', '客户人员', 0);
INSERT INTO `user_info_manage` (`id`, `user_name`, `user_address`, `user_remark`, `is_delete_status`) VALUES (7, '夏航', '香港大埔区樟树滩路45号', '客户人员', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
